'Amort3.0.sam.sht
	'AmiSoft
'Loan Amortization
'LOAN AMOUNT
'    Years of loan
'INTEREST RATE
'    Year to display--->
^month
^principal 
^interest
	^balance
(12*(F5-1))
+$C$4/($Z$13^A8)*($Z$13^A8-$Z$15)/(1-$Z$15)
'  Payment
+AMT*I/(1-(V^(12*TERM)))
+1+A8
+$F$8-C9
+$I*D8
+$C$4/($Z$13^A9)*($Z$13^A9-$Z$15)/(1-$Z$15)
+1+A9
+$F$8-C10
+$I*D9
+$C$4/($Z$13^A10)*($Z$13^A10-$Z$15)/(1-$Z$15)
	'  Total
+1+A10
+$F$8-C11
Q+$I*D10
+$C$4/($Z$13^A11)*($Z$13^A11-$Z$15)/(1-$Z$15)
'  Payments
+1+A11
+$F$8-C12
"+$I*D11
+$C$4/($Z$13^A12)*($Z$13^A12-$Z$15)/(1-$Z$15)
'  This year
@SUM(B9..C20)
+C5/12
+1+A12
+$F$8-C13
+$I*D12
+$C$4/($Z$13^A13)*($Z$13^A13-$Z$15)/(1-$Z$15)
+1/(1+I)
+1+A13
+$F$8-C14
+$I*D13
=+$C$4/($Z$13^A14)*($Z$13^A14-$Z$15)/(1-$Z$15)
+1+A14
C.+$F$8-C15
np+$I*D14
+$C$4/($Z$13^A15)*($Z$13^A15-$Z$15)/(1-$Z$15)
D+V^(12*TERM)
+1+A15
W+$F$8-C16
+$I*D15
+$C$4/($Z$13^A16)*($Z$13^A16-$Z$15)/(1-$Z$15)
+1+A16
+$F$8-C17
@TZn{
]+$I*D16
+$C$4/($Z$13^A17)*($Z$13^A17-$Z$15)/(1-$Z$15)
+1+A17
+$F$8-C18
I+$I*D17
+$C$4/($Z$13^A18)*($Z$13^A18-$Z$15)/(1-$Z$15)
+1+A18
+$F$8-C19
+$I*D18
+$C$4/($Z$13^A19)*($Z$13^A19-$Z$15)/(1-$Z$15)
+1+A19
+$F$8-C20
3+$I*D19
+$C$4/($Z$13^A20)*($Z$13^A20-$Z$15)/(1-$Z$15)
!'                               
Amort3.0.sa
Amort3.0.sa
Amort3.0.sa
Amort3.0.sa
Amort3.0.sa
Amort3.0.sa
Amort3.0.sa
Amort3.0.sa
month
mort3.0.sa
mort3.0.sa
mort3.0.sa